class Bugs < ActiveRecord::Migration
  def self.up
    query = <<-_SQL
      CREATE TABLE `bugs` (
          `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
          `priority` INT NOT NULL ,
          `summary` TEXT NULL ,
          `description` TEXT NOT NULL ,
          `status` INT NOT NULL ,
        UNIQUE (
          `id`
        )
    ) ENGINE = MYISAM ;
    _SQL

    execute query
  end

  def self.down
    execute "DROP TABLE `bugs` "
  end
end
